Concatenate (x & y)

Basic and Crystal syntax.

Concatenate (x & y) and Concatenate operator (x +y) are synonymous if both operands x and y are strings.

Usage

x & y

Concatenates the values of x and y, and returns the result as a String. x and y can be of one of the types Number, Boolean, Currency, Date, Time, DateTime, and String.

Examples

The following examples are applicable to both Crystal and Basic syntax:

10 & 20

Returns the String "10.0000020.00000", where the number formatting for this formula field specifies 5 decimal places. Use CStr if you want to specify how to format a String when converting from a different type. In this example, you can use CStr on the Number values a and b to convert and format each of them to a String, and then concatenate the resultant Strings.

True & False

Returns the String "TrueFalse".

"The meeting is " & #Nov 15. 1999#

Returns the String "The meeting is 11/15/99 12:00:00 AM".

"Boy" & "Girl"

Returns the String "BoyGirl".

Comments

The format of the returned value is determined by the format that has been set up for that formula field of the corresponding type of operands. However, if you want to convert to a String from a value of a different type and be able to specify formatting for the resultant string, you can use CStr.

Related topics

Concatenate operator (x +y)



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com